// AddGroupItem event - Occurs after a new Group Item has been inserted to Items collection.
private void exgrid1_AddGroupItem(object sender,int   Item)
{
	exgrid1.Items.set_ItemDividerLine(Item,exontrol.EXGRIDLib.DividerLineEnum.EmptyLine);
}
//this.exgrid1.AddGroupItem += new exontrol.EXGRIDLib.exg2antt.AddGroupItemEventHandler(this.exgrid1_AddGroupItem);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[1].SortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exgrid1.EndUpdate();

// CellStateChanged event - Fired after cell's state has been changed.
private void exgrid1_CellStateChanged(object sender,int   Item,int   ColIndex)
{
	System.Diagnostics.Debug.Print( exgrid1.Items.get_CellCaption(Item,ColIndex) );
}
//this.exgrid1.CellStateChanged += new exontrol.EXGRIDLib.exg2antt.CellStateChangedEventHandler(this.exgrid1_CellStateChanged);

// Click event - Occurs when the user presses and then releases the left mouse button over the grid control.
private void exgrid1_Click(object sender)
{
	int h = exgrid1.get_ItemFromPoint(-1,-1,c,hit);
	exgrid1.Items.set_CellState(h,c,1);
}
//this.exgrid1.Click += new exontrol.EXGRIDLib.exg2antt.ClickEventHandler(this.exgrid1_Click);

exgrid1.BeginUpdate();
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.ShowFocusRect = false;
(exgrid1.Columns.Add("Default") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("entire");
	h = var_Items.AddItem("Radio <b>1");
	var_Items.set_CellRadioGroup(h,0,100);
	var_Items.set_CellHasRadioButton(h,0,true);
	var_Items.set_CellState(h,0,1);
	h = var_Items.get_SplitCell(h,0);
	var_Items.set_CellValue(0,h,"Radio <b>2");
	var_Items.set_CellRadioGroup(0,h,100);
	var_Items.set_CellHasRadioButton(0,h,true);
	h = var_Items.get_SplitCell(0,h);
	var_Items.set_CellValue(0,h,"Radio <b>3");
	var_Items.set_CellRadioGroup(0,h,100);
	var_Items.set_CellHasRadioButton(0,h,true);
	h = var_Items.AddItem("entire");
exgrid1.EndUpdate();

// SelectionChanged event - Fired after a new item has been selected.
private void exgrid1_SelectionChanged(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		int hFocusItem = var_Items.FocusItem;
		var_Items.set_CellValue(exgrid1.Columns["active"].Data,"active","");
		var_Items.set_CellValue(hFocusItem,"active","<c><font symbol>·");
		var_Items.set_CellVAlignment(hFocusItem,"active",exontrol.EXGRIDLib.VAlignmentEnum.exBottom);
		exgrid1.Columns["active"].Data = hFocusItem;
}
//this.exgrid1.SelectionChanged += new exontrol.EXGRIDLib.exg2antt.SelectionChangedEventHandler(this.exgrid1_SelectionChanged);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.ShowFocusRect = false;
exgrid1.ContinueColumnScroll = true;
exgrid1.ScrollBySingleLine = true;
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragScrollOnShortTouch | exontrol.EXGRIDLib.AutoDragEnum.exAutoDragScroll;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("") as exontrol.EXGRIDLib.Column);
	var_Column.Key = "active";
	var_Column.Position = 0;
	var_Column.AllowSizing = false;
	var_Column.Width = 12;
	var_Column.Data = exgrid1.Items.FocusItem;
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exgrid1.CountLockedColumns = 1;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_SelectItem(var_Items.get_NextVisibleItem(var_Items.FocusItem),true);
exgrid1.EndUpdate();

exgrid1.ColumnAutoResize = false;
exgrid1.ContinueColumnScroll = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Select * From foxcode.DBF","Provider=vfpoledb;Data Source=C:\\Program Files\\Microsoft Visual FoxPro 9\\",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);

exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.ContinueColumnScroll = true;
exgrid1.ScrollBySingleLine = true;
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragScrollOnShortTouch | exontrol.EXGRIDLib.AutoDragEnum.exAutoDragScroll;

exgrid1.BeginUpdate();
exgrid1.BackColorAlternate32 = 0x7ff0f0f0;
exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
	var_Items.AddItem("Item 4");
	var_Items.AddItem("Item 5");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.SearchColumnIndex = 0;
exgrid1.Columns.Add("Info");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.PathSeparator = " ; ";
	var_Items.set_SelectItem(var_Items.InsertItem(var_Items.InsertItem(var_Items.InsertItem(var_Items.InsertItem(null,null,"Root"),null,"Child"),null,"Sub-Child"),null,"Sub-Sub-Child"),true);
	var_Items.set_ExpandItem(0,true);
	System.Diagnostics.Debug.Print( var_Items.get_FullPath(var_Items.FocusItem) );
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Tasks");
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Date") as exontrol.EXGRIDLib.Column);
		var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
		var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Task 1"),1,Convert.ToDateTime("12/13/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellValue(var_Items.AddItem("Task 2"),1,Convert.ToDateTime("12/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellValue(var_Items.AddItem("Task 2"),1,Convert.ToDateTime("12/15/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
exgrid1.ConditionalFormats.Add("%1 = #12/14/2001#",null).Bold = true;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "len(value) ? ( (longdate(date(value)) left 3) + ' ' + day(date(value)) + '/' + month(date(value)) + '/' + (year(date(value)) ri" +
"ght 2) ) : '' )";
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exDateAllowNullDate,true);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("5/12/2012",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(null);
	var_Items.AddItem(Convert.ToDateTime("5/14/2012",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int   Item,int   ColIndex,ref object   NewValue)
{
	exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exgrid1.SortOnClick = exontrol.EXGRIDLib.SortOnClickEnum.exNoSort;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exgrid1.Indent = 13;
exgrid1.HeaderVisible = false;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Items");
	(var_Columns.Add("Quantity") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
	(var_Columns.Add("Value") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Items");
	var_Items.set_CellValue(h,2,"sum(current,dir,dbl(%1)*dbl(%2))");
	var_Items.set_CellValueFormat(h,2,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_FormatCell(h,2,"`Total: `+ value");
	var_Items.set_CellHAlignment(h,2,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_CellBold(h,2,true);
	var_Items.set_CellEditorVisible(h,2,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorHidden);
	var_Items.set_CellEditorVisible(h,1,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorHidden);
	int h1 = var_Items.InsertItem(h,null,"Item 1");
	var_Items.set_CellValue(h1,1,10);
	var_Items.set_CellValue(h1,2,3);
	h1 = var_Items.InsertItem(h,null,"Item 2");
	var_Items.set_CellValue(h1,1,20);
	var_Items.set_CellValue(h1,2,4);
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

// CellStateChanged event - Fired after cell's state has been changed.
private void exgrid1_CellStateChanged(object sender,int   Item,int   ColIndex)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.set_CellValue(Item,2,var_Items.get_CellState(Item,0));
}
//this.exgrid1.CellStateChanged += new exontrol.EXGRIDLib.exg2antt.CellStateChangedEventHandler(this.exgrid1_CellStateChanged);

exgrid1.BeginUpdate();
exgrid1.ShowFocusRect = false;
exgrid1.SelBackMode = exontrol.EXGRIDLib.BackModeEnum.exTransparent;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = exgrid1.ConditionalFormats.Add("%2 != 0",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = exontrol.EXGRIDLib.FormatApplyToEnum.exFormatToItems;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.Width = 16;
	var_Column.AllowSizing = false;
exgrid1.Columns.Add("Information");
(exgrid1.Columns.Add("Hidden") as exontrol.EXGRIDLib.Column).Visible = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(""),1,"This is a bit of text associated");
	int h = var_Items.AddItem("");
	var_Items.set_CellValue(h,1,"This is a bit of text associated");
	var_Items.set_CellState(h,0,1);
	var_Items.set_CellValue(var_Items.AddItem(""),1,"This is a bit of text associated");
exgrid1.EndUpdate();

// FocusChanged event - Occurs when a new cell is focused.
private void exgrid1_FocusChanged(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.set_CellBackColor(var_Items.FocusItem,exgrid1.FocusColumnIndex,Color.FromArgb(255,0,0));
}
//this.exgrid1.FocusChanged += new exontrol.EXGRIDLib.exg2antt.FocusChangedEventHandler(this.exgrid1_FocusChanged);

exgrid1.BeginUpdate();
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column1");
	var_Columns.Add("Column2");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Cell 1.1"),1,"Cell 1.2");
	var_Items.set_CellValue(var_Items.AddItem("Cell 2.1"),1,"Cell 2.2");
exontrol.EXGRIDLib.Items var_Items1 = exgrid1.Items;
	var_Items1.set_SelectItem(var_Items1[1],true);
exgrid1.FocusColumnIndex = 1;
exgrid1.EndUpdate();

// FocusChanged event - Occurs when a new cell is focused.
private void exgrid1_FocusChanged(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.set_CellBackColor(var_Items.FocusItem,exgrid1.FocusColumnIndex,Color.FromArgb(255,0,0));
}
//this.exgrid1.FocusChanged += new exontrol.EXGRIDLib.exg2antt.FocusChangedEventHandler(this.exgrid1_FocusChanged);

exgrid1.BeginUpdate();
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.DefaultItemHeight = 36;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("Column1") as exontrol.EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("Column2") as exontrol.EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("Column3") as exontrol.EXGRIDLib.Column).Visible = false;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("FormatLevel") as exontrol.EXGRIDLib.Column);
		var_Column.FormatLevel = "(0/1),2";
		var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellFormatLevel,var_Column.FormatLevel);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Cell 1.1");
	var_Items.set_CellValue(h,1,"Cell 1.2");
	var_Items.set_CellValue(h,2,"Cell 1.3");
	h = var_Items.AddItem("Cell 2.1");
	var_Items.set_CellValue(h,1,"Cell 2.2");
	var_Items.set_CellValue(h,2,"Cell 2.3");
exontrol.EXGRIDLib.Items var_Items1 = exgrid1.Items;
	var_Items1.set_SelectItem(var_Items1[1],true);
exgrid1.FocusColumnIndex = 2;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowExclude | exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem | exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
	var_Items.AddItem("Item 4");
exontrol.EXGRIDLib.Column var_Column1 = exgrid1.Columns[0];
	var_Column1.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilterExclude | exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item 1|Item 4";
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("Format") as exontrol.EXGRIDLib.Column).FormatColumn = "len(value) ? (value format '0') : '' ";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(10);
	var_Items.AddItem(null);
	var_Items.AddItem(-8);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exBackColorFilter,Color.FromArgb(255,255,255));
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exShowFocusItem | exontrol.EXGRIDLib.FilterListEnum.exShowCheckBox | exontrol.EXGRIDLib.FilterListEnum.exSortItemsAsc | exontrol.EXGRIDLib.FilterListEnum.exLeafItems;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("First");
	var_Columns.Add("Second");
	var_Columns.Add("Third");
exgrid1.SortBarVisible = true;
exgrid1.SingleSort = false;
exgrid1.AllowGroupBy = true;
exgrid1.Layout = "SingleSort = \"C0:1\";MultipleSort = \"C1:2 C2:1\"";

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("First");
	var_Columns.Add("Second");
	var_Columns.Add("Third");
exgrid1.SortBarVisible = true;
exgrid1.SingleSort = false;
exgrid1.Layout = "SingleSort = \"C0:1\"";

exgrid1.BeginUpdate();
exgrid1.HotBackColor = Color.FromArgb(0,0,255);
exgrid1.HotForeColor = Color.FromArgb(255,255,255);
(exgrid1.Columns.Add("Value") as exontrol.EXGRIDLib.Column).Visible = false;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("USD") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "len(%0) ? ((0:=dbl(%0)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + `USD `+ (=:0 format ``)";
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("EUR") as exontrol.EXGRIDLib.Column);
	var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column1.FormatColumn = "len(%0) ? ((0:=0.72*dbl(%0)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + `EUR `+ (=:0 format ``)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("1.23");
	var_Items.AddItem("2.34");
	var_Items.AddItem("9.94");
	var_Items.AddItem("11.94");
	var_Items.AddItem("1000");
exgrid1.HotBackColor = exgrid1.BackColor;
exgrid1.HotForeColor = exgrid1.ForeColor;
exgrid1.EndUpdate();

(exgrid1.Columns.Add("Value") as exontrol.EXGRIDLib.Column).Visible = false;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("USD") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "len(%0) ? ((0:=dbl(%0)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + `USD `+ (=:0 format ``)";
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("EUR") as exontrol.EXGRIDLib.Column);
	var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column1.FormatColumn = "len(%0) ? ((0:=0.72*dbl(%0)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + `EUR `+ (=:0 format ``)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("1.23");
	var_Items.AddItem("2.34");
	var_Items.AddItem("9.94");
	var_Items.AddItem("11.94");
	var_Items.AddItem("1000");

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("City") as exontrol.EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("Start") as exontrol.EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("End") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;
exgrid1.ColumnsFloatBarSortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;

// FocusChanged event - Occurs when a new cell is focused.
private void exgrid1_FocusChanged(object sender)
{
	System.Diagnostics.Debug.Print( "Active/Focus-Column:" );
	System.Diagnostics.Debug.Print( exgrid1.Columns[exgrid1.FocusColumnIndex].Caption );
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		System.Diagnostics.Debug.Print( "Active/Focus-Row/Item:" );
		System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,exgrid1.FocusColumnIndex) );
}
//this.exgrid1.FocusChanged += new exontrol.EXGRIDLib.exg2antt.FocusChangedEventHandler(this.exgrid1_FocusChanged);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("C1") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	(var_Columns.Add("C2") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	(var_Columns.Add("C3") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(1);
	var_Items.set_CellValue(h,1,2);
	var_Items.set_CellValue(h,2,3);
	h = var_Items.AddItem(3);
	var_Items.set_CellValue(h,1,1);
	var_Items.set_CellValue(h,2,2);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Padding") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellSingleLine,false);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellPaddingLeft,6);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellPaddingRight,6);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellPaddingTop,6);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellPaddingBottom,6);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("padding");
	var_Items.AddItem("padding");
exgrid1.EndUpdate();

exgrid1.BackColorAlternate = Color.FromArgb(240,240,240);
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Lines") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellSingleLine,false);
exgrid1.ItemsAllowSizing = exontrol.EXGRIDLib.ItemsAllowSizingEnum.exResizeItem;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Line 1<br>Line 2");
	var_Items.set_ItemMinHeight(h,36);
	var_Items.set_ItemHeight(h,var_Items.get_ItemMinHeight(h));
	var_Items.set_ItemMaxHeight(h,var_Items.get_ItemMinHeight(h));
	h = var_Items.AddItem("Line 1<br>Line 2");
	var_Items.set_ItemMinHeight(h,48);
	var_Items.set_ItemHeight(h,var_Items.get_ItemMinHeight(h));
	var_Items.set_ItemMaxHeight(h,var_Items.get_ItemMinHeight(h));
	h = var_Items.AddItem("Line 1<br>Line 2");
	var_Items.set_ItemMinHeight(h,64);
	var_Items.set_ItemHeight(h,var_Items.get_ItemMinHeight(h));
	var_Items.set_ItemMaxHeight(h,var_Items.get_ItemMinHeight(h));

// MouseMove event - Occurs when the user moves the mouse.
private void exgrid1_MouseMoveEvent(object sender,short   Button,short   Shift,int   X,int   Y)
{
	exgrid1.ShowToolTip("This is bit of text that's shown when the user hovers the cell","Column",0,"+16","+16");
}
//this.exgrid1.MouseMoveEvent += new exontrol.EXGRIDLib.exg2antt.MouseMoveEventHandler(this.exgrid1_MouseMoveEvent);

exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("tooltip");

// ToolTip event - Fired when the control prepares the object's tooltip.
private void exgrid1_ToolTip(object sender,int   Item,int   ColIndex,ref bool   Visible,ref int   X,ref int   Y,int   CX,int   CY)
{
	X = 0;
	Y = 0;
}
//this.exgrid1.ToolTip += new exontrol.EXGRIDLib.exg2antt.ToolTipEventHandler(this.exgrid1_ToolTip);

exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellToolTip(var_Items.AddItem("tooltip"),0,"This is bit of text that's shown when the user hovers the cell");

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Text") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortDate;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/11/1998",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("1/20/2014",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("1/1/2013",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	int h = var_Items.AddItem("min(all,dir,date(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'MIN: '+value");
	h = var_Items.AddItem("max(all,dir,date(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'MAX: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Text") as exontrol.EXGRIDLib.Column).SortType = exontrol.EXGRIDLib.SortTypeEnum.SortString;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("aha");
	var_Items.AddItem("baba");
	var_Items.AddItem("aaha");
	var_Items.AddItem("aka");
	int h = var_Items.AddItem("min(all,dir,str(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'MIN: '+value");
	h = var_Items.AddItem("max(all,dir,str(%0))");
	var_Items.set_SortableItem(h,false);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_CellHAlignment(h,0,exontrol.EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,0,"'MAX: '+value");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABeEGACAADACAxRDgMQBQKAAzQFAYbBlBaERiGQYIJhUAIIRZGMQxXAcMQvDSKQJhGDAADENAxAJCI4DBIgZQNDwZQIkCY4ZDKHIfRzNAASJ" +
"IkTQPBKfYDGOLhSh6IJGRpPEIxdJMBr+fZ9QApeoYVj2J4eUCAFBxDRsZw8BiNAbkOi4Jp1f5nVJaFSxCKoSxbNqSBpGCzoJrKdI0R5JES2BAddTLBKzX7tHArLgSJ5d" +
"SrLMrwSKcRR1HSbIDyGaMUiCSqGVjWNZ5FREM46AAGbDgMILEgOZpoYDFVTZTKFCS7I6Eb40CCbCyPJQAabgWo4KAAZThNi7QAua4bTr7HqibLAexaJDOc4HVSgMLlIY" +
"EkIeg2iybAjDkfhMFuHY7mQT4xB0TBnFoUQ6i+cg2j2SIvHqVZIl8cB+BwTgPA4NRdjycg2FoHhuAMUZuHGUAwCECQUAaEYMHQHRHCGFRZEQAABO2AwRFCWQJAoGxECW" +
"TBHkGBxpg8RhYBMbJbD+TBzByfwwAwCIOCWCQiGiJgogqYh4hYIQ/k2cx9gEYQAAiRgqgsYx4mYLIOiOCMjjCTA4iScw8mMOQWEaEZkGkDgpguUIYm4SITmUCQaDuExj" +
"gkRhWhQJQ0A4ToVmWSQWFkAAljkdhiheZgZgoXIZCUWYaF2GgihmKhrg4JRJjYboVmaSIiHOHQnAkahph2ZYJmQAAxAwSQKESHwkFkKgoiAIxIHoPIimOOg2DiCgoiQJ" +
"RQTYQxwn8MgMgoMoPiaYoaGCfw4A4CJNAkOpcGQBCAg==");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x1000000);
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Check") as exontrol.EXGRIDLib.Column);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellPaddingLeft,2);
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.DefaultItemHeight = 22;
exgrid1.ShowFocusRect = true;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("");
	var_Items.AddItem("");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Column/Cell-Same") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
	var_Editor.AddItem(0,"Zero",null);
	var_Editor.AddItem(1,"One",null);
	var_Editor.AddItem(2,"Two",null);
exontrol.EXGRIDLib.Editor var_Editor1 = (exgrid1.Columns.Add("Column/Cell-Different") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(null);
	int h = var_Items.AddItem(0);
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(h,1);
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
		var_Editor2.AddItem(3,"Three",null);
		var_Editor2.AddItem(4,"Four",null);
	var_Items.set_CellValue(h,1,3);
	var_Items.AddItem(null);
	h = var_Items.AddItem(0);
	exontrol.EXGRIDLib.Editor var_Editor3 = var_Items.get_CellEditor(h,1);
		var_Editor3.EditType = exontrol.EXGRIDLib.EditTypeEnum.CheckListType;
		var_Editor3.AddItem(1,"Single",null);
		var_Editor3.AddItem(2,"Double",null);
	var_Items.set_CellValue(h,1,3);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.DefaultItemHeight = 22;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Fonts") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.FontType;
	var_Editor.ClearItems();
	var_Editor.AddItem(0,"Calibri",null);
	var_Editor.AddItem(1,"Arial",null);
	var_Editor.AddItem(2,"Rockwell",null);
	var_Editor.AddItem(3,"Tahoma",null);
	var_Editor.SortItems(true,null);
	var_Editor.DropDownRows = 4;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Tahoma");
exgrid1.EndUpdate();

// AnchorClick event - Occurs when an anchor element is clicked.
private void exgrid1_AnchorClick(object sender,string   AnchorID,string   Options)
{
	System.Diagnostics.Debug.Print( AnchorID.ToString() );
	System.Diagnostics.Debug.Print( Options.ToString() );
}
//this.exgrid1.AnchorClick += new exontrol.EXGRIDLib.exg2antt.AnchorClickEventHandler(this.exgrid1_AnchorClick);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	(var_Columns.Add("Car") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("<a mazda_1;options for 1>Mazda <b>1</b></a>");
	var_Items.AddItem("<a mazda_2;options for 2>Mazda <b>2</b></a>");
	var_Items.AddItem("<a mazda_3;options for 3a>Mazda <b>3.a</b></a>");
	var_Items.AddItem("<a mazda_3;options for 3b>Mazda <b>3.b</b></a>");
exgrid1.EndUpdate();

// CellStateChanged event - Fired after cell's state has been changed.
private void exgrid1_CellStateChanged(object sender,int   Item,int   ColIndex)
{
	System.Diagnostics.Debug.Print( "CheckBox Changed:" );
	System.Diagnostics.Debug.Print( exgrid1.Items.get_CellState(Item,ColIndex).ToString() );
}
//this.exgrid1.CellStateChanged += new exontrol.EXGRIDLib.exg2antt.CellStateChangedEventHandler(this.exgrid1_CellStateChanged);

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Check") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellState(var_Items.AddItem("Check 1"),0,0);
	var_Items.set_CellState(var_Items.AddItem("Check 2"),0,1);
	var_Items.set_CellState(var_Items.AddItem("Check 3"),0,0);
	var_Items.set_CellState(var_Items.AddItem("Check 4"),0,1);
exgrid1.EndUpdate();

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int   Item,int   ColIndex,ref object   NewValue)
{
	System.Diagnostics.Debug.Print( "CheckBox Changed:" );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Check") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(0);
	var_Items.AddItem(1);
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Appearance var_Appearance = exgrid1.VisualAppearance;
	var_Appearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
	var_Appearance.Add(2,"c:\\exontrol\\images\\pushed.ebn");
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Progress") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.ProgressBarType;
	var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exProgressBarBackColor,16777216);
	var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exProgressBarMarkTicker,33554432);
exgrid1.Items.AddItem(33);

exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BVEIQAAYAQGKIYBkAKBQAGaAoDDMOQwQwAAxjGKEEwsACEIrjKCRShyCYZRhGcTSBCIZBqEqSZLiEZRQCWIAzATGYBRfIUEgjBM6ExwG78e" +
"gBHp/ZpkACIJJAaRjHQdJxGKKMQB9DIhCZpeKhWgkKIJBzOEyBRC4ERBGqNGrsIgLEqWZpnWhaNpWXYTLyBN64LhuK46g53O6wLxvK6hEr2dJ/YBcIAOfghf4NQ7EMRx" +
"LC8Mw3BDvYDkOAABAIgI=");
exgrid1.SelBackColor32 = 0x1fffffe;
exgrid1.ShowFocusRect = false;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_ItemBackColor(var_Items.AddItem("red"),Color.FromArgb(255,0,0));
	var_Items.set_ItemBackColor(var_Items.AddItem("blue"),Color.FromArgb(0,0,255));
	var_Items.set_ItemBackColor(var_Items.AddItem("green"),Color.FromArgb(0,255,0));
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.SelBackMode = exontrol.EXGRIDLib.BackModeEnum.exTransparent;
exgrid1.ShowFocusRect = false;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_ItemBackColor(var_Items.AddItem("red"),Color.FromArgb(255,0,0));
	var_Items.set_ItemBackColor(var_Items.AddItem("blue"),Color.FromArgb(0,0,255));
	var_Items.set_ItemBackColor(var_Items.AddItem("green"),Color.FromArgb(0,255,0));
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.ShowFocusRect = true;
exgrid1.Columns.Add("Items");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_ItemBackColor(var_Items.AddItem("red"),Color.FromArgb(255,0,0));
	var_Items.set_ItemBackColor(var_Items.AddItem("blue"),Color.FromArgb(0,0,255));
	var_Items.set_ItemBackColor(var_Items.AddItem("green"),Color.FromArgb(0,255,0));
exgrid1.EndUpdate();

// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
private void exgrid1_BeforeExpandItem(object sender,int   Item,ref object   Cancel)
{
	System.Diagnostics.Debug.Print( "BeforeExpandItem" );
	System.Diagnostics.Debug.Print( Item.ToString() );
	exgrid1.Items.InsertItem(Item,null,"new child");
}
//this.exgrid1.BeforeExpandItem += new exontrol.EXGRIDLib.exg2antt.BeforeExpandItemEventHandler(this.exgrid1_BeforeExpandItem);

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Items") as exontrol.EXGRIDLib.Column);
		var_Column.DisplayFilterButton = true;
		var_Column.FilterList = exontrol.EXGRIDLib.FilterListEnum.exRootItems;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_ItemHasChildren(var_Items.InsertItem(null,null,"Group 1"),true);
	var_Items.set_ItemHasChildren(var_Items.InsertItem(null,null,"Group 2"),true);
exgrid1.EndUpdate();

// OLEStartDrag event is not supported. Use the DragEnter,DragLeave,DragOver, DragDrop ... events.
exgrid1.OLEDropMode = exontrol.EXGRIDLib.exOLEDropModeEnum.exOLEDropManual;
exgrid1.VisualAppearance.Add(1,"C:\\Program Files\\Exontrol\\ExList\\Sample\\VB\\DragDrop\\insert_bottom.ebn");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exListOLEDropPosition,0x1000000);
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");

// OLEStartDrag event is not supported. Use the DragEnter,DragLeave,DragOver, DragDrop ... events.
exgrid1.OLEDropMode = exontrol.EXGRIDLib.exOLEDropModeEnum.exOLEDropManual;
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exListOLEDropPosition,Color.FromArgb(1,0,0));
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender,int   Item)
{
	exgrid1.Items.set_CellEditorVisible(Item,0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	exgrid1.Items.set_CellEditorVisible(Item,1,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);

// EditOpen event - Occurs when the edit operation starts.
private void exgrid1_EditOpen(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		object v = var_Items.get_CellValue(var_Items.FocusItem,0);
		string c = var_Items.get_CellCaption(var_Items.FocusItem,0);
	exontrol.EXGRIDLib.Editor var_Editor = exgrid1.Columns[1].Editor;
		var_Editor.ClearItems();
		var_Editor.AddItem(v,c.ToString(),null);
}
//this.exgrid1.EditOpen += new exontrol.EXGRIDLib.exg2antt.EditOpenEventHandler(this.exgrid1_EditOpen);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("DropDownList") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
		var_Editor.AddItem(1,"First",null);
		var_Editor.AddItem(2,"Second",null);
		var_Editor.AddItem(3,"Third",null);
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
(exgrid1.Columns.Add("DropDownList-Related") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(1),1,-1);
	var_Items.set_CellValue(var_Items.AddItem(2),1,-1);
	var_Items.set_CellValue(var_Items.AddItem(3),1,-1);
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerTop);
	var_Items.set_CellEditorVisible(h,0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorHidden);
	var_Items.set_CellSingleLine(h,0,exontrol.EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
	var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellValue(h,0,"The drop down editor in the second column is filled during the <b>EditOpen event</b>, and the values are based on the selection" +
" on the first column.");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Number");
exgrid1.Columns.Add("Format");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("1.23");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField | exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellValue(h,1,"2 * %0 + ` <font ;6><fgcolor=808080>(2 * Number)`");
	h = var_Items.AddItem("1.23");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField | exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellValue(h,1,"3 * %0 + ` <font ;6><fgcolor=808080>(3 * Number)`");
	h = var_Items.AddItem("1.23");
	var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exComputedField | exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellValue(h,1,"currency(%0) + ` <font ;6><fgcolor=808080>( Currency(Number) )`");
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Column - DropDownList") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
	var_Editor.AddItem(1,"First item",null);
	var_Editor.AddItem(2,"Second item",null);
	var_Editor.AddItem(3,"Third item",null);
(exgrid1.Columns.Add("Cell - DropDownList") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(1);
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(h,1);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
		var_Editor1.AddItem(1,"<b>First</b> item",null);
		var_Editor1.AddItem(2,"<b>Second</b> item",null);
		var_Editor1.AddItem(3,"<b>Third</b> item",null);
		var_Editor1.AddItem(4,"<b>Forth</b> item",null);
	var_Items.set_CellValue(h,1,2);
	h = var_Items.AddItem(2);
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(h,1);
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
		var_Editor2.AddItem(1,"<b>Aka First</b> item",null);
		var_Editor2.AddItem(2,"<b>Aka Second</b> item",null);
		var_Editor2.AddItem(3,"<b>Aka Third</b> item",null);
		var_Editor2.AddItem(4,"<b>Aka Forth</b> item",null);
	var_Items.set_CellValue(h,1,2);

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int   Item,int   ColIndex,ref object   NewValue)
{
	System.Diagnostics.Debug.Print( "NewValue is" );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("DropDownList-String") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
	var_Editor.AddItem(1,"NYC|New York City",null);
	var_Editor.AddItem(2,"CJN|Cluj Napoca",null);
exontrol.EXGRIDLib.Editor var_Editor1 = (exgrid1.Columns.Add("DropDownList-Numeric") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
	var_Editor1.AddItem(1,"New York City",null);
	var_Editor1.AddItem(2,"Cluj Napoca",null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("NYC"),1,2);

// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender,int   Item,int   ColIndex,ref object   NewValue)
{
	System.Diagnostics.Debug.Print( "NewValue:" );
	System.Diagnostics.Debug.Print( NewValue.ToString() );
	System.Diagnostics.Debug.Print( "EditingValue:" );
	System.Diagnostics.Debug.Print( exgrid1.EditingText );
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);

exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
exgrid1.Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column);
	var_Column.Width = 64;
	var_Column.AllowSizing = false;
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor.Mask = ";;;rich";
exgrid1.Columns.Add("Empty");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("This is a bit ot long text");
	var_Items.AddItem("");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("DropDown") as exontrol.EXGRIDLib.Column);
	var_Column.Width = 64;
	var_Column.AllowSizing = false;
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownType;
		var_Editor.AddItem(1,"First item. This is a bit ot long text",null);
		var_Editor.AddItem(2,"Second item. This is a bit ot long text",null);
		var_Editor.AddItem(3,"Third item. This is a bit ot long text",null);
		var_Editor.Mask = ";;;rich";
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("PickEdit") as exontrol.EXGRIDLib.Column);
	var_Column1.Width = 64;
	var_Column1.AllowSizing = false;
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Column1.Editor;
		var_Editor1.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20;
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.PickEditType;
		var_Editor1.AddItem(1,"First item. This is a bit ot long text",null);
		var_Editor1.AddItem(2,"Second item. This is a bit ot long text",null);
		var_Editor1.AddItem(3,"Third item. This is a bit ot long text",null);
		var_Editor1.Mask = ";;;rich";
exgrid1.Columns.Add("Empty");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("First item. This is a bit ot long text"),1,"Second item. This is a bit ot long text");
	int h = var_Items.AddItem("First item. This is a bit ot long text");
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(h,0);
		var_Editor2.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20;
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownType;
		var_Editor2.AddItem(1,"First item. This is a bit ot long text",null);
		var_Editor2.AddItem(2,"Second item. This is a bit ot long text",null);
		var_Editor2.AddItem(3,"Third item. This is a bit ot long text",null);
	var_Items.set_CellValue(h,1,"Second item. This is a bit ot long text");
	exontrol.EXGRIDLib.Editor var_Editor3 = var_Items.get_CellEditor(h,1);
		var_Editor3.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20;
		var_Editor3.EditType = exontrol.EXGRIDLib.EditTypeEnum.PickEditType;
		var_Editor3.AddItem(1,"First item. This is a bit ot long text",null);
		var_Editor3.AddItem(2,"Second item. This is a bit ot long text",null);
		var_Editor3.AddItem(3,"Third item. This is a bit ot long text",null);
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
	var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exDropDownBackColor,15790320);
	var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exDropDownForeColor,65793);
exgrid1.Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
exgrid1.EndUpdate();

// EditClose event - Occurs when the edit operation ends.
private void exgrid1_EditCloseEvent(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.ClearCellBackColor(var_Items.FocusItem,exgrid1.FocusColumnIndex);
}
//this.exgrid1.EditCloseEvent += new exontrol.EXGRIDLib.exg2antt.EditCloseEventHandler(this.exgrid1_EditCloseEvent);

// EditOpen event - Occurs when the edit operation starts.
private void exgrid1_EditOpen(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.set_CellBackColor(var_Items.FocusItem,exgrid1.FocusColumnIndex,Color.FromArgb(255,0,0));
	exontrol.EXGRIDLib.Items var_Items1 = exgrid1.Items;
		var_Items1.set_CellValue(var_Items1.FocusItem,exgrid1.FocusColumnIndex,exgrid1.Items.get_CellValue(exgrid1.Items.FocusItem,exgrid1.FocusColumnIndex));
}
//this.exgrid1.EditOpen += new exontrol.EXGRIDLib.exg2antt.EditOpenEventHandler(this.exgrid1_EditOpen);

exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
(exgrid1.Columns.Add("C1") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
(exgrid1.Columns.Add("C2") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("v1"),1,"v2");
	var_Items.set_CellValue(var_Items.AddItem("v3"),1,"v4");

exgrid1.BeginUpdate();
exgrid1.CauseValidateValue = exontrol.EXGRIDLib.ValidateValueType.exValidateCell;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Date") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
	var_Editor.Mask = "!99/99/9999;1;;empty=1,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character" +
"!,select=4,overtype";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(null);
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(null);
exgrid1.EndUpdate();

exgrid1.Columns.Add("DropDown");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	exontrol.EXGRIDLib.Editor var_Editor = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor.DropDownAlignment = exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor1.DropDownAlignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor2.DropDownAlignment = exontrol.EXGRIDLib.AlignmentEnum.LeftAlignment;
	exontrol.EXGRIDLib.Editor var_Editor3 = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor3.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor3.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20;
	exontrol.EXGRIDLib.Editor var_Editor4 = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor4.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor4.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20 | exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	exontrol.EXGRIDLib.Editor var_Editor5 = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor5.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor5.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20 | exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;

(exgrid1.Columns.Add("DropDown") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	exontrol.EXGRIDLib.Editor var_Editor = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x20;
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US"))),0);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor1.DropDownAlignment = (exontrol.EXGRIDLib.AlignmentEnum)0x10;
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Float") as exontrol.EXGRIDLib.Column);
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor.Mask = ";;;float,digits=0,grouping=,invalid=empty,warning=invalid character";
exgrid1.Items.AddItem(192278);
exgrid1.Items.AddItem(1000);

exgrid1.BeginUpdate();
exgrid1.CauseValidateValue = exontrol.EXGRIDLib.ValidateValueType.exValidateCell;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.Columns.Add("Date");
exgrid1.Columns.Add("Mask");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	exontrol.EXGRIDLib.Editor var_Editor = var_Items.get_CellEditor(h,0);
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor.Mask = "{1,12}/{1,31}/{1950,2050};1;;select=1,warning=Invalid character!,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</" +
"b>!,validateas=1";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(h,0);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor1.Mask = "!99/99/9999;1;;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character!," +
"select=4,overtype";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(h,0);
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor2.Mask = "!99/99/9999;;;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character!,s" +
"elect=4,overtype";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	exontrol.EXGRIDLib.Editor var_Editor3 = var_Items.get_CellEditor(h,0);
		var_Editor3.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor3.Mask = "!99/99/9999;; ;select=4,overtype,empty,warning=Invalid character!,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'<" +
"/b>!,validateas=1";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	exontrol.EXGRIDLib.Editor var_Editor4 = var_Items.get_CellEditor(h,0);
		var_Editor4.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor4.Mask = "![0-9 ][0-9 ]/[0-9 ][0-9 ]/[0-9 ][0-9 ][0-9 ][0-9 ];1;;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%" +
"mask%>'</b>!,warning=Invalid character!,select=4,leading= ";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_FormatCell(h,0,"len(value) ? shortdateF(value) : ``");
	exontrol.EXGRIDLib.Editor var_Editor5 = var_Items.get_CellEditor(h,0);
		var_Editor5.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor5.Mask = "!99/99/9999;1;;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character!," +
"select=4,overtype,leading";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_FormatCell(h,0,"len(value) ? shortdateF(value) : ``");
	exontrol.EXGRIDLib.Editor var_Editor6 = var_Items.get_CellEditor(h,0);
		var_Editor6.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor6.Mask = "!00/00/0000;1;;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character!," +
"select=4,overtype,leading";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_FormatCell(h,0,"len(value) ? shortdateF(value) : ``");
	exontrol.EXGRIDLib.Editor var_Editor7 = var_Items.get_CellEditor(h,0);
		var_Editor7.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor7.Mask = "!00/00/0000;;0;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character!," +
"select=4,overtype";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_FormatCell(h,0,"len(value) ? shortdateF(value) : ``");
	exontrol.EXGRIDLib.Editor var_Editor8 = var_Items.get_CellEditor(h,0);
		var_Editor8.EditType = exontrol.EXGRIDLib.EditTypeEnum.DateType;
		var_Editor8.Mask = "!00/00/0000;;;empty,validateas=1,invalid=Invalid date\\, for the input mask <br><b>'<%mask%>'</b>!,warning=Invalid character!,s" +
"elect=1,overtype";
	var_Items.set_CellValue(h,1,var_Items.get_CellEditor(h,0).Mask);
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Float") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "value format `0`";
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor.Mask = ";;;float,digits=0";
exgrid1.Items.AddItem(192278);

exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Float") as exontrol.EXGRIDLib.Column);
	var_Column.FormatColumn = "value format ``";
	exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor.Mask = ";;;float";
exgrid1.Items.AddItem(192278);

exgrid1.CauseValidateValue = exontrol.EXGRIDLib.ValidateValueType.exValidateCell;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.FullRowSelect = exontrol.EXGRIDLib.CellSelectEnum.exColumnSel;
(exgrid1.Columns.Add("Phone") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem(null);
	exontrol.EXGRIDLib.Editor var_Editor = var_Items.get_CellEditor(h,0);
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor.Mask = "!(999) 000 0000;1;;select=1,empty,overtype,warning=invalid characer,invalid=The value you entered isn't appropriate for the inp" +
"ut mask <b>'<%mask%>'</b> specified for this field.";
	h = var_Items.AddItem("0123");
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(h,0);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor1.Mask = "!(999) 000 0000;2;;select=4";
	h = var_Items.AddItem("0123");
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(h,0);
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor2.Mask = "`Phone: `!(999) 000-0000";
	h = var_Items.AddItem("(074) 876-1222");
	exontrol.EXGRIDLib.Editor var_Editor3 = var_Items.get_CellEditor(h,0);
		var_Editor3.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
		var_Editor3.Mask = "!(999) 000-0000;0";

(exgrid1.Columns.Add("Color") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(255);
	int h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor = var_Items.get_CellEditor(h,0);
		var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor.Mask = "`RGB(`{0,255}\\,{0,255}\\,{0,255}`)`;;0";
	h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor1 = var_Items.get_CellEditor(h,0);
		var_Editor1.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor1.Mask = "`&H`XXXXXXXX`&`;;0;overtype,insertype,warning=Wrong!";
	h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor2 = var_Items.get_CellEditor(h,0);
		var_Editor2.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor2.Mask = "`0x`XX `0x`XX `0x`XX;;0;overtype,insertype,warning=Wrong!";
	h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor3 = var_Items.get_CellEditor(h,0);
		var_Editor3.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor3.Mask = "R{0,255} G{0,255} B{0,255};;0;overtype,insertype,warning=Wrong!";
	h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor4 = var_Items.get_CellEditor(h,0);
		var_Editor4.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor4.Mask = "`(hexa) RGB 0x`XXXXXX;;0;overtype,insertype,warning=Wrong!";
	h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor5 = var_Items.get_CellEditor(h,0);
		var_Editor5.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor5.Mask = "`(decimal) Red: `{0,255}` Green: `{0,255}` Blue: `{0,255};;0;overtype,insertype,warning=Wrong!";
	h = var_Items.AddItem(255);
	exontrol.EXGRIDLib.Editor var_Editor6 = var_Items.get_CellEditor(h,0);
		var_Editor6.EditType = exontrol.EXGRIDLib.EditTypeEnum.ColorType;
		var_Editor6.Mask = "`(combine) Red: `{0,255}` Green: 0x`XX` Blue: `{0,255};;0;overtype,insertype,warning=Wrong!";

// UserEditorClose event - Fired the user editor is about to be opened.
private void exgrid1_UserEditorClose(object sender,object   Obj,int   Item,int   ColIndex)
{
	// Items.CellValue(Item,ColIndex) = Object.Value
}
//this.exgrid1.UserEditorClose += new exontrol.EXGRIDLib.exg2antt.UserEditorCloseEventHandler(this.exgrid1_UserEditorClose);

// UserEditorOleEvent event - Occurs when an user editor fires an event.
private void exgrid1_UserEditorOleEvent(object sender,object   Obj,exontrol.EXGRIDLib.OleEvent   Ev,ref bool   CloseEditor,int   Item,int   ColIndex)
{
	System.Diagnostics.Debug.Print( Ev.ToString() );
}
//this.exgrid1.UserEditorOleEvent += new exontrol.EXGRIDLib.exg2antt.UserEditorOleEventEventHandler(this.exgrid1_UserEditorOleEvent);

// UserEditorOpen event - Occurs when an user editor is about to be opened.
private void exgrid1_UserEditorOpen(object sender,object   Obj,int   Item,int   ColIndex)
{
	// Object.Value = Me.Items.CellValue(Item,ColIndex)
}
//this.exgrid1.UserEditorOpen += new exontrol.EXGRIDLib.exg2antt.UserEditorOpenEventHandler(this.exgrid1_UserEditorOpen);

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Exontrol.ComboBox") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.UserEditorType;
	var_Editor.UserEditor("Exontrol.ComboBox","");
	// Add 'ExComboBox 1.0 Control Library(ExComboBox.dll)' reference to your project.
	exontrol.EXCOMBOBOXLib.excombobox var_ComboBox = (var_Editor.UserEditorObject as exontrol.EXCOMBOBOXLib.excombobox);
		var_ComboBox.BeginUpdate();
		var_ComboBox.Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList;
		var_ComboBox.ColumnAutoResize = false;
		// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
		ADODB.Recordset rs = new ADODB.Recordset();
			rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
		var_ComboBox.DataSource = (rs as ADODB.Recordset);
		var_ComboBox.MinHeightList = 128;
		var_ComboBox.SearchColumnIndex = 0;
		var_ComboBox.UseTabKey = false;
		var_ComboBox.EndUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.DefaultItemHeight = 21;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_CellEditorVisible(var_Items.AddItem(10248),0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	var_Items.set_CellEditorVisible(var_Items.AddItem(10249),0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	var_Items.set_CellEditorVisible(var_Items.AddItem(10250),0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
exgrid1.EndUpdate();

exgrid1.ShowLockedItems = true;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exgrid1.Columns.Add("C1");
exgrid1.Columns.Add("C2");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
	var_Items.set_ItemBackColor(h,Color.FromArgb(128,128,128));
	var_Items.set_ItemForeColor(h,Color.FromArgb(255,255,255));
	var_Items.set_CellValue(h,0,"footer c1");
	var_Items.set_CellValue(h,1,"footer c2");
	var_Items.set_CellValue(var_Items.AddItem("cell"),1,"cell");

exgrid1.ShowLockedItems = true;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exgrid1.Columns.Add("C1");
exgrid1.Columns.Add("C2");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
	int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemBackColor(h,Color.FromArgb(128,128,128));
	var_Items.set_ItemForeColor(h,Color.FromArgb(255,255,255));
	var_Items.set_CellValue(h,0,"footer c1");
	var_Items.set_CellValue(h,1,"footer c2");
	var_Items.set_CellValue(var_Items.AddItem("cell"),1,"cell");

exgrid1.SortBarVisible = true;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add(0.ToString());
	var_Columns.Add(1.ToString());
	var_Columns.Add(2.ToString());
	var_Columns.Add(3.ToString());
	var_Columns.Add(4.ToString());
exgrid1.Layout = "multiplesort=\"C3:1 C4:2\";singlesort=\"C2:1\"";

exgrid1.ColumnAutoResize = true;
exgrid1.Columns.Add("Sizable");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("F") as exontrol.EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.Width = 16;

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("DropDown") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.PickEditType;
	var_Editor.AddItem(0,"",null);
	var_Editor.AddItem(1,"The first item",null);
	var_Editor.AddItem(2,"The second item",null);
	var_Editor.AddItem(3,"The third item",null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("The first item");
	var_Items.AddItem("");
	var_Items.AddItem("The third item");

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("DropDown") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.PickEditType;
	var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exPickAllowEmpty,true);
	var_Editor.AddItem(1,"The first item",null);
	var_Editor.AddItem(2,"The second item",null);
	var_Editor.AddItem(3,"The third item",null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("The first item");
	var_Items.AddItem("");
	var_Items.AddItem("The third item");

exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("C1");
	var_Columns.Add("C2");
	var_Columns.Add("C3");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("unselectable item");
	var_Items.set_CellValue(h,1,"unselectable item");
	var_Items.set_CellValue(h,2,"unselectable item");
	var_Items.set_SelectableItem(h,false);
	h = var_Items.AddItem("selectable cell");
	var_Items.set_CellValue(h,1,"unselectable cell");
	var_Items.set_CellEnabled(h,1,false);
	var_Items.set_CellForeColor(h,1,Color.FromArgb(0,0,0));
	var_Items.set_CellValue(h,2,"disabled cell");
	var_Items.set_CellEnabled(h,2,false);
	h = var_Items.AddItem("disabled item");
	var_Items.set_CellValue(h,1,"disabled item");
	var_Items.set_CellValue(h,2,"disabled item");
	var_Items.set_EnableItem(h,false);
	var_Items.set_SelectableItem(h,false);
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exDisableSigns | exontrol.EXGRIDLib.NumericEnum.exFloatInteger;
exgrid1.Items.AddItem(1.22);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exDisablePlus | exontrol.EXGRIDLib.NumericEnum.exFloatInteger;
exgrid1.Items.AddItem(1.22);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.Numeric = exontrol.EXGRIDLib.NumericEnum.exFloatInteger;
exgrid1.Items.AddItem(1.22);

exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor;
	var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
	var_Editor.Numeric = (exontrol.EXGRIDLib.NumericEnum)0xfc | exontrol.EXGRIDLib.NumericEnum.exDisableSigns | exontrol.EXGRIDLib.NumericEnum.exFloatInteger | exontrol.EXGRIDLib.NumericEnum.exFloat;
exgrid1.Items.AddItem(1);

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Value");
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("CellSingleLine = False") as exontrol.EXGRIDLib.Column);
		var_Column.ComputedField = "%0";
		var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellSingleLine,false);
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("FormatColumn/replace CRLF") as exontrol.EXGRIDLib.Column);
		var_Column1.ComputedField = "%0";
		var_Column1.FormatColumn = "value replace `\\r\\n` with ``";
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("FormatColumn/replace TAB,CRLF") as exontrol.EXGRIDLib.Column);
		var_Column2.ComputedField = "%0";
		var_Column2.FormatColumn = "(value replace `\\t` with ``) replace `\\r\\n` with ``";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("a\\ta\\r\\nb\\tb");

// DblClick event - Occurs when the user dblclk the left mouse button over an object.
private void exgrid1_DblClick(object sender,short   Shift,int   X,int   Y)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		int h = var_Items.get_CellChecked(1234);
		var_Items.set_CellHasCheckBox(0,h,true);
		var_Items.set_CellState(0,h,0);
		var_Items.set_CellHasCheckBox(0,h,false);
}
//this.exgrid1.DblClick += new exontrol.EXGRIDLib.exg2antt.DblClickEventHandler(this.exgrid1_DblClick);

// SelectionChanged event - Fired after a new item has been selected.
private void exgrid1_SelectionChanged(object sender)
{
	exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
		var_Items.set_CellState(var_Items.FocusItem,0,1);
}
//this.exgrid1.SelectionChanged += new exontrol.EXGRIDLib.exg2antt.SelectionChangedEventHandler(this.exgrid1_SelectionChanged);

exgrid1.MarkSearchColumn = false;
exgrid1.SelBackColor = Color.FromArgb(255,255,128);
exgrid1.SelForeColor = Color.FromArgb(0,0,0);
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Radio 1");
	var_Items.set_CellHasRadioButton(h,0,true);
	var_Items.set_CellRadioGroup(h,0,1234);
	h = var_Items.AddItem("Radio 2");
	var_Items.set_CellHasRadioButton(h,0,true);
	var_Items.set_CellRadioGroup(h,0,1234);
	var_Items.set_CellState(h,0,1);
	h = var_Items.AddItem("Radio 3");
	var_Items.set_CellHasRadioButton(h,0,true);
	var_Items.set_CellRadioGroup(h,0,1234);

exgrid1.BeginUpdate();
exgrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
exgrid1.TreeColumnIndex = -1;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.HeaderHeight = 24;
exgrid1.DefaultItemHeight = 24;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Image") as exontrol.EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.Width = 32;
	var_Column.HTMLCaption = "<img>1</img>";
	var_Column.HeaderAlignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	var_Column.Alignment = exontrol.EXGRIDLib.AlignmentEnum.CenterAlignment;
	var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exgrid1.Columns.Add("Rest");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("<img>1</img>");
	var_Items.AddItem("<img>2</img>");
	var_Items.AddItem("<img>3</img>");
exgrid1.EndUpdate();

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Default");
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Format.1") as exontrol.EXGRIDLib.Column);
		var_Column.ComputedField = "%0";
		var_Column.FormatColumn = "dateF(value) replace `/` with `-`";
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Format.2") as exontrol.EXGRIDLib.Column);
		var_Column1.ComputedField = "%0";
		var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column1.FormatColumn = "`<b>`+ shortdate(value) + `</b> ` + timeF(value)";
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Format.3") as exontrol.EXGRIDLib.Column);
		var_Column2.ComputedField = "%0";
		var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column2.FormatColumn = "( dateF(value) replace `/` with `-` ) + ` <b>`+ ( weekday(value) case ( 0 : `Su`; 1 : `Mo`; 2 : `Tu`; 3 : `We`; 4 : `Th`; 5 : `" +
"Fr`; 6 : `Sa`) )";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("1/2/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("C0") as exontrol.EXGRIDLib.Column);
		var_Column.ExpandColumns = "1,2";
		var_Column.DisplayExpandButton = false;
	var_Columns.Add("C1");
	var_Columns.Add("C2");
	var_Columns.Add("C3");
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("C4") as exontrol.EXGRIDLib.Column);
		var_Column1.ExpandColumns = "5,6";
		var_Column1.DisplayExpandButton = false;
	var_Columns.Add("C5");
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("C6") as exontrol.EXGRIDLib.Column);
		var_Column2.ExpandColumns = "6,7";
		var_Column2.DisplayExpandButton = false;
	var_Columns.Add("C7");
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.BackColorLevelHeader = Color.FromArgb(240,240,240);
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Photo") as exontrol.EXGRIDLib.Column);
		var_Column.AllowSizing = false;
		var_Column.Width = 32;
	var_Columns.Add("Personal Info");
	var_Columns.Add("Title");
	var_Columns.Add("Name");
	var_Columns.Add("First");
	var_Columns.Add("Last");
	var_Columns.Add("Address");
	var_Columns["Personal Info"].ExpandColumns = "2,3";
	exontrol.EXGRIDLib.Column var_Column1 = var_Columns["Name"];
		var_Column1.ExpandColumns = "4,5";
		var_Column1.Expanded = false;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exontrol.EXGRIDLib.Column var_Column = exgrid1.Columns[0];
	var_Column.MaxWidthAutoResize = 32;
	var_Column.WidthAutoResize = true;
exgrid1.EndUpdate();

exgrid1.ColumnAutoResize = false;
exgrid1.HeaderHeight = 28;
exgrid1.DefaultItemHeight = 24;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Column 1") as exontrol.EXGRIDLib.Column);
		var_Column.HTMLCaption = "Column <b><off 2><font ;6>1";
		var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column);
		var_Column1.HTMLCaption = "Column <b><off 2><font ;6>2";
		var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Column 3") as exontrol.EXGRIDLib.Column);
		var_Column2.HTMLCaption = "Column <b><off 2><font ;6>3";
		var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("Item <font ;6><off 4>1");
	var_Items.set_CellValue(h,1,"Item <font ;6><off -6>2");
	var_Items.set_CellValue(h,2,"Item <b><font ;6><off -6>2<off 4>3<off 4>1");

exgrid1.MarkSearchColumn = false;
exgrid1.TreeColumnIndex = -1;
(exgrid1.Columns.Add("1") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,255);
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("2") as exontrol.EXGRIDLib.Column);
	var_Column.Width = 32;
	var_Column.AllowSizing = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("The Item's background color inherits the Column.Def(exCellBackColor)");
	var_Items.set_ItemDivider(h,0);
	h = var_Items.AddItem("The Item's background color inherits the CellBackColor()");
	var_Items.set_ItemDivider(h,0);
	var_Items.set_CellBackColor(h,null,Color.FromArgb(0,255,0));
	h = var_Items.AddItem("The Item's background color inherits the CellBackColor(), while the split inherits from the Column.Def(exCellBackColor) ");
	var_Items.set_ItemDivider(h,0);
	var_Items.set_CellBackColor(h,null,Color.FromArgb(0,255,0));
	object var_SplitCell = var_Items.get_SplitCell(h,0);
	h = var_Items.AddItem("The Item's background color inherits the CellBackColor()");
	var_Items.set_ItemDivider(h,0);
	var_Items.set_CellBackColor(h,null,Color.FromArgb(0,255,0));
	var_Items.set_CellBackColor(0,var_Items.get_SplitCell(h,0),Color.FromArgb(0,0,255));

exgrid1.MarkSearchColumn = false;
exgrid1.TreeColumnIndex = -1;
exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("C1") as exontrol.EXGRIDLib.Column);
	var_Column.Width = 17;
	var_Column.AllowSizing = false;
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("C2") as exontrol.EXGRIDLib.Column);
	var_Column1.Width = 17;
	var_Column1.AllowSizing = false;
exgrid1.Columns.Add("Other");
exgrid1.ColumnAutoResize = true;

exgrid1.BeginUpdate();
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.Columns.Add("Default");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("entire");
	h = var_Items.AddItem("split 1");
	h = var_Items.get_SplitCell(h,0);
	var_Items.set_CellValue(0,h,"split 2");
	h = var_Items.get_SplitCell(0,h);
	var_Items.set_CellValue(0,h,"split 3");
	h = var_Items.AddItem("entire");
exgrid1.EndUpdate();

// FilterChange event - Occurs when filter was changed.
private void exgrid1_FilterChange(object sender)
{
	System.Diagnostics.Debug.Print( "If negative, the filter is present, else not" );
	System.Diagnostics.Debug.Print( exgrid1.Items.VisibleItemCount.ToString() );
}
//this.exgrid1.FilterChange += new exontrol.EXGRIDLib.exg2antt.FilterChangeEventHandler(this.exgrid1_FilterChange);

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.TreeColumnIndex = -1;
exgrid1.FilterInclude = exontrol.EXGRIDLib.FilterIncludeEnum.exMatchingItemsOnly;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Column") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column.Filter = "C1";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("R1");
	var_Items.InsertItem(h,null,"C1");
	var_Items.InsertItem(h,null,"C2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("R2");
	var_Items.InsertItem(h,null,"C1");
	var_Items.InsertItem(h,null,"C2");
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.TreeColumnIndex = -1;
exgrid1.FilterInclude = exontrol.EXGRIDLib.FilterIncludeEnum.exMatchingItemsOnly;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Column") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column.Filter = "C1|C2";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("R1");
	var_Items.InsertItem(h,null,"C1");
	var_Items.InsertItem(h,null,"C2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("R2");
	var_Items.InsertItem(h,null,"C1");
	var_Items.InsertItem(h,null,"C2");
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.FilterInclude = exontrol.EXGRIDLib.FilterIncludeEnum.exMatchingItemsOnly;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Column") as exontrol.EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column.Filter = "C1|C2";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	int h = var_Items.AddItem("R1");
	var_Items.InsertItem(h,null,"C1");
	var_Items.InsertItem(h,null,"C2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("R2");
	var_Items.InsertItem(h,null,"C1");
	var_Items.InsertItem(h,null,"C2");
exgrid1.ApplyFilter();
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
exgrid1.Layout = "Select=\"0\";SingleSort=\"C0:2\";Columns=1";
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
exgrid1.Layout = "gBjAAwAAuABmABpABsAB0ABlAByhoAPIAOEPAA9gYABoABQAgUEg0XN4AOcJicKkpujMbjsfkMFk0YhkQgUOjUEl8gjcGO0ok8KMULjEaGMcj08kQAO8oMkTNEtGwAG" +
"QAqc7gUlhh1ABtAEsk9GpEfhElgVcsMupNlnlonlaAFcr0shUsp8QPEtnVJqJhmcIhUMh0QiU5sYAqMngUSuEMw07k8Qv0SgVRrNEuVflF2jF5x9JyNEm0TjQijemyE0" +
"jE3t+YruauoAu4Az1qj9BzRn0UzksSnAA0xDjY6qnAw8OiUQ0dwzN0zWz2t7j8/xURAGNvWH6k8xlEhklhEI0O/6QAgI=";
exgrid1.EndUpdate();

exgrid1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
exgrid1.BackColorHeader32 = 0x1000000;
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,0x12d86ff);

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.VisualAppearance.Add(2,"c:\\exontrol\\images\\normal.ebn");
exgrid1.VisualAppearance.Add(3,"c:\\exontrol\\images\\pushed.ebn");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatAppearance,0x2000000);
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,0x3000000);
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatCaptionBackColor,Color.FromArgb(246,245,240));
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.VisualAppearance.Add(3,"c:\\exontrol\\images\\pushed.ebn");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,0x3000000);
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.VisualAppearance.Add(2,"c:\\exontrol\\images\\normal.ebn");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatAppearance,0x2000000);
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,Color.FromArgb(246,245,240));
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatCaptionBackColor,Color.FromArgb(246,245,240));
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Column 3") as exontrol.EXGRIDLib.Column);
		var_Column.Visible = false;
		var_Column.Enabled = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
	exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Column 3") as exontrol.EXGRIDLib.Column);
		var_Column.Visible = false;
		var_Column.AllowDragging = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exColumnsFloatBar,"Hidden Columns");
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exgrid1.ColumnAutoResize = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;

exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[1].SortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;
exgrid1.EndUpdate();
exgrid1.BeginUpdate();
exgrid1.EnsureVisibleColumn(0);
exgrid1.Items.set_ExpandItem(0,false);
exgrid1.EndUpdate();

// AddGroupItem event - Occurs after a new Group Item has been inserted to Items collection.
private void exgrid1_AddGroupItem(object sender,int   Item)
{
	exgrid1.Items.set_ExpandItem(Item,false);
}
//this.exgrid1.AddGroupItem += new exontrol.EXGRIDLib.exg2antt.AddGroupItemEventHandler(this.exgrid1_AddGroupItem);

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[1].SortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;
exgrid1.EndUpdate();

exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.SortBarVisible = true;
exgrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
exgrid1.AllowGroupBy = true;
exgrid1.Columns[1].SortOrder = exontrol.EXGRIDLib.SortOrderEnum.SortAscending;
exgrid1.EndUpdate();
exgrid1.EnsureVisibleColumn(0);
exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
	var_Items.set_ExpandItem(var_Items.get_RootItem(0),false);
	var_Items.set_ExpandItem(var_Items.get_RootItem(1),false);
	var_Items.set_ExpandItem(var_Items.get_RootItem(2),false);
exgrid1.EndUpdate();